/*
 Navicat MySQL Data Transfer

 Source Server         : localhost
 Source Server Version : 50513
 Source Host           : localhost
 Source Database       : ng

 Target Server Version : 50513
 File Encoding         : utf-8

 Date: 07/13/2011 21:58:50 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `real_estate_rental`
-- ----------------------------
DROP TABLE IF EXISTS `real_estate_rental`;
CREATE TABLE `real_estate_rental` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `street_id` int(11) NOT NULL,
  `street_number` varchar(20) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `type` smallint(6) NOT NULL,
  `bedroom` smallint(6) NOT NULL,
  `ensuite` smallint(6) NOT NULL,
  `bathroom` smallint(6) NOT NULL,
  `car_space` smallint(6) NOT NULL,
  `land_area` int(11) NOT NULL,
  `floor_area` int(11) NOT NULL,
  `primary_use` smallint(6) NOT NULL,
  `percent_first_to_last_list_price` decimal(9,2) NOT NULL,
  `days_on_the_market` int(11) NOT NULL,
  `start_rent_date` date NOT NULL,
  `latest_rent_date` date NOT NULL,
  `first_advertised_date` date NOT NULL,
  `latest_rent_description` varchar(255) NOT NULL,
  `last_advertised_date` date NOT NULL,
  `agency_name` varchar(255) NOT NULL,
  `agent_name` varchar(255) NOT NULL,
  `period_code` smallint(6) NOT NULL,
  `daily_rent` decimal(9,2) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `slug` (`slug`),
  KEY `real_estate_rental_539ecf1b` (`street_id`),
  CONSTRAINT `street_id_refs_id_bf1d2857` FOREIGN KEY (`street_id`) REFERENCES `location_street` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `real_estate_rental`
-- ----------------------------
BEGIN;
INSERT INTO `real_estate_rental` VALUES
('1', '1', '1', '1', '0', '4', '2', '2', '2', '430', '300', '0', '5.00', '3', '1998-01-01', '2011-02-12', '1998-01-04', 'Nice and large room, rent out soon', '2011-02-09', 'LJ Hooker', 'anne', '1', '530.00'),
('2', '1', '7/8', '2', '1', '3', '1', '2', '1', '180', '180', '0', '10.00', '4', '1997-01-01', '2011-01-12', '1997-01-05', 'Nice and large room, rent out soon', '2011-01-08', 'Ray White', 'jack', '2', '390.00'),
('3', '1', '10/8', '3', '1', '3', '1', '2', '1', '150', '180', '0', '13.00', '5', '1998-02-01', '2011-01-12', '1998-02-06', 'Nice and large room, rent out soon', '2011-01-07', 'Ray White', 'jack', '1', '378.00'),
('4', '1', '12/8', '4', '1', '3', '1', '2', '1', '165', '180', '0', '8.00', '6', '1998-03-01', '2011-01-12', '1998-03-07', 'Nice and large room, rent out soon', '2011-01-06', 'LJ Hooker', 'anne', '2', '385.00'),
('5', '1', '10', '5', '0', '4', '2', '4', '2', '530', '350', '0', '6.00', '3', '1998-04-01', '2011-01-12', '1998-04-04', 'Nice and large room, rent out soon', '2011-01-09', 'Yong', 'sam', '1', '640.00'),
('6', '1', '6', '6', '0', '5', '3', '4', '3', '680', '400', '0', '7.00', '4', '1998-05-01', '2011-02-12', '1998-05-05', 'Nice and large room, rent out soon', '2011-02-08', 'Yong', 'sam', '2', '670.00'),
('7', '1', '4', '7', '0', '4', '2', '3', '2', '600', '320', '0', '9.00', '5', '1998-05-01', '2011-04-12', '1998-05-06', 'Nice and large room, rent out soon', '2011-04-07', 'Yong', 'sam', '1', '780.00'),
('8', '2', '104', '8', '2', '0', '0', '2', '5', '200', '200', '1', '5.00', '6', '1998-05-05', '2011-05-12', '1998-05-11', 'Nice and large room, rent out soon', '2011-05-06', 'Yong', 'sam', '2', '550.00'),
('9', '2', '150', '9', '2', '0', '0', '2', '6', '300', '300', '1', '5.00', '9', '1998-05-15', '2011-06-12', '1998-05-24', 'Nice and large room, rent out soon', '2011-06-03', 'LJ Hooker', 'anne', '1', '630.00'),
('10', '2', '400', '10', '2', '0', '0', '2', '5', '270', '370', '1', '5.00', '4', '1998-06-01', '2011-03-10', '1998-06-05', 'Nice and large room, rent out soon', '2011-03-06', 'LJ Hooker', 'anne', '2', '890.00'),
('11', '2', '250', '11', '3', '0', '0', '2', '6', '400', '400', '1', '5.00', '4', '1999-01-10', '2011-03-12', '1999-01-14', 'Nice and large room, rent out soon', '2011-03-08', 'Ray White', 'jack', '1', '1002.00'),
('12', '2', '280', '12', '3', '0', '0', '2', '8', '500', '500', '1', '6.00', '4', '1999-02-12', '2011-07-10', '1999-02-16', 'Nice and large room, rent out soon', '2011-07-06', 'Ray White', 'jack', '2', '1300.00'),
('13', '2', '283', '13', '3', '0', '0', '2', '6', '500', '500', '1', '6.00', '5', '1999-03-01', '2011-07-09', '1999-03-06', 'Nice and large room, rent out soon', '2011-07-04', 'Ray White', 'jack', '1', '580.00'),
('14', '2', '264', '14', '3', '0', '0', '2', '4', '300', '300', '1', '6.00', '5', '1999-03-24', '2011-07-08', '1999-03-29', 'Nice and large room, rent out soon', '2011-07-03', 'Ray White', 'jack', '2', '780.00'),
('15', '3', '97', '15', '0', '4', '2', '3', '2', '540', '420', '0', '7.00', '5', '1999-04-01', '2011-07-07', '1999-04-06', 'Nice and large room, rent out soon', '2011-07-02', 'LJ Hooker', 'paul', '1', '480.00'),
('16', '3', '96', '16', '0', '4', '2', '3', '2', '700', '480', '0', '7.00', '3', '1999-05-02', '2011-06-06', '1999-05-05', 'Nice and large room, rent out soon', '2011-06-03', 'LJ Hooker', 'paul', '2', '590.00'),
('17', '3', '94', '17', '0', '5', '3', '4', '2', '800', '460', '0', '7.00', '3', '1999-06-09', '2011-06-05', '1999-06-12', 'Nice and large room, rent out soon', '2011-06-02', 'LJ Hooker', 'paul', '1', '630.00'),
('18', '3', '93', '18', '0', '5', '3', '3', '3', '890', '520', '0', '10.00', '8', '1999-07-16', '2011-04-04', '1999-07-24', 'Nice and large room, rent out soon', '2011-03-27', 'LJ Hooker', 'paul', '2', '510.00'),
('19', '3', '88', '19', '0', '6', '4', '4', '3', '1200', '600', '0', '8.00', '6', '1999-08-20', '2011-03-03', '1999-08-26', 'Nice and large room, rent out soon', '2011-02-25', 'Ray White', 'jack', '1', '900.00'),
('20', '3', '83', '20', '5', '0', '0', '0', '0', '1500', '0', '4', '6.00', '6', '1999-09-23', '2011-05-02', '1999-09-29', 'Nice and large room, rent out soon', '2011-04-26', 'Yong', 'sam', '2', '710.00'),
('21', '3', '85', '21', '7', '0', '0', '0', '0', '1009', '0', '4', '6.00', '2', '2000-10-12', '2011-07-01', '2000-10-14', 'Nice and large room, rent out soon', '2011-06-29', 'LJ Hooker', 'anne', '1', '880.00');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
